---
title: "SQL-001: Fetch claim display and confidentiality fields"
summary: Executes the PK82284_CLAIM_TASK.SELECT_ADDITIONAL_FIELDS stored procedure to populate claim number, worker name, policy details, and confidentiality flags.
status: draft
owner: SAIF Documentation
last_reviewed: 2026-08-21
library: SAIF.Business.Tasks.Claim
reference_type: embedded
---

# SQL-001 Fetch claim display and confidentiality fields

Executed directly by `clsClaimTask.GetExtraFields` (not through the standard criteria-driven Before/After lifecycle) to bulk-load claim display attributes and confidentiality flags for list-retrieved claim tasks, since the task row itself carries only `CLAIM_ID`.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-001 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` — no owner prefix in the call string |
| **Command type** | StoredProcedure |
| **Business object** | `clsClaimTask` |
| **Criteria property** | `Criteria.extraSQL` (non-`IBusinessCriteria` property) |
| **Lifecycle method** | `clsClaimTask.GetExtraFields`, invoked from `PostFill` (list path) |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:ClaimId` | Input | Decimal (`ClaimID` property) | — | Identifies the claim whose additional display/confidentiality fields are requested. |
| `:ClaimNum` | InputOutput | String | 7 | Returns the claim number without the check character; seeded from `m_ClaimNum`. |
| `:SAIFClaimNum` | InputOutput | String | 8 | Returns the SAIF claim number including the check character; seeded from `m_SAIFClaimNum`. |
| `:WorkerName` | InputOutput | String | 100 | Returns the injured worker name; may subsequently be replaced with `"Confidential"` by [BR-MY-01](../business-rules.md#br-my-01-confidential-worker-name-redaction). |
| `:PolicyName` | InputOutput | String | 100 | Returns the policy (employer) name. |
| `:WorkStatus` | InputOutput | String | 100 | Returns the claim work-status description. |
| `:conflictFlag` | InputOutput | String | 5 | Worker-conflict indicator; `.NET` maps `"Y"` → `IsWorkerConflict = True`. |
| `:exposureCode` | InputOutput | String | 5 | Exposure indicator; `.NET` maps any value other than `"0"` → `IsExposure = True`. |
| `:healthIssue` | InputOutput | String | 5 | Health-issue indicator; `.NET` maps `"Y"` → `IsHealthIssue = True`. |
| `:hostileWrkr` | InputOutput | String | 5 | Hostile-worker indicator; `.NET` maps any non-space value → `IsHostileWrkr = True`. |

> Parameter types and lengths are the .NET-side binding declarations (`AddParm(...)`) only. Because the PL/SQL source could not be retrieved, the true PL/SQL parameter modes and datatypes are unknown.**

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| N/A | — | The tables read by `PK82284_CLAIM_TASK.SELECT_ADDITIONAL_FIELDS` reside inside the Oracle package body and are not visible from this repository.** |

## Sample SQL

```sql
-- Stored procedure call as it appears in code
CALL PK82284_CLAIM_TASK.SELECT_ADDITIONAL_FIELDS(
  :ClaimId,
  :ClaimNum,
  :SAIFClaimNum,
  :WorkerName,
  :PolicyName,
  :WorkStatus,
  :conflictFlag,
  :exposureCode,
  :healthIssue,
  :hostileWrkr)
-- Procedure body resides in the Oracle database and is not present in this repository.
-- Source retrieval via the Legends CLI was unavailable for this run; status: not-found.
```

Corresponding VB request setup, for traceability:

```vb
DataRequest.RequestType = DataRequestType.NonQuery
DataRequest.CommandType = CommandType.StoredProcedure
DataRequest.SQLStatement = MyCriteria.extraSQL   ' "PK82284_CLAIM_TASK.SELECT_ADDITIONAL_FIELDS"
DataRequest.ID = "ExtraFields"
```

## Operations and processes
- [Load claim display/confidentiality fields](../operations/op-4-load-claim-display-fields.md)
- [Enrich a loaded claim task](../operations/op-3-enrich-loaded-claim-task.md)
- [Retrieve and redact "my tasks"](../operations/op-6-retrieve-and-redact-my-tasks.md)

## Business rules
- [BR-MY-01: Confidential worker name redaction](../business-rules.md#br-my-01-confidential-worker-name-redaction)

## Sources
- SAIF.Business.Tasks.Claim/clsClaimTask.vb